QlikView: Creating Line Charts, Combo Charts, Pivot Tables, & Block Charts

QlikView: Creating Line Charts, Combo Charts, Pivot Tables, & Block Charts

• discover the key concepts covered in this course
• use QlikView to create and format a line chart
• perform regression analysis using trendlines
• create various customized line charts and explore the use of stacked area charts
• create basic combo charts with bars and lines
• customize combo charts by adding labels and lines
• explore the use of stacked bar charts
• use a pivot table to access aggregate values in hierarchical data
• combine a straight table with a pivot table and access currently selected data
• create a treemap, also called a block chart, to visualize hierarchical data
• create a donut chart and use buttons to perform operations on data
• summarize the key concepts covered in this course

At QlikView’s core is a patented associative engine allowing for an associate experience across data types regardless of where they’re stored.

In this course, you’ll explore how to use your time-series data to build line charts. You’ll then customize these charts in various ways, such as using smoothing techniques to represent approximations or multiple lines to demonstrate values in more than one variable.

Next, you’ll configure stacked area charts to visualize the composition of variables over time before using combo charts to visualize multiple chart types on the same axes.

Finally, you’ll examine how you can explore hierarchical data using pivot tables and block charts. You’ll identify the differences between pivot tables and straight tables and distinguish how each of these represents underlying data.

QlikView: Creating Mekko Charts, Radar Charts, Gauge Charts, & Scatter Charts

QlikView: Creating Mekko Charts, Radar Charts, Gauge Charts, & Scatter Charts

• discover the key concepts covered in this course
• implement Mekko charts to view the composition of sub-categories within each category in a chart
• use the line/arrow sheet object to perform actions
• create funnel charts to calculate the relative success rates of linear sequential process steps
• create basic gauge charts to compare the current value of a variable against its target value
• customize the look and feel of gauge charts
• work with different kinds of gauge charts, such as tanks, thermometers, and joysticks
• use radar charts to plot multidimensional data
• create a basic scatter plot
• customize scatter plots to have three dimensions using the sizes of data points
• configure a scatter plot with a search bar, slider, and animations
• summarize the key concepts covered in this course

In this course, you'll learn how to use QlikView charts for visualization purposes, such as Mekko charts, funnel charts, and gauge charts.

You'll start by using a Bar Mekko chart to show the relative importance of bars by adding a bar width variable. You'll then use a funnel chart to visualize the comparable success rates of steps in a linear sequential process, such as the number of product views, interactions, and buys on an e-commerce site.

Next, you'll use gauge charts to track how a current metric value performs against a pre-defined target value. You'll then use various QlikView gauge charts, such as the tank, thermometer, joystick, and test tube variants.

Finally, you'll build and customize a scatter chart using sliders, animations, and a search box.

QlikView: Getting Started with QlikView for Data Visualization

QlikView: Getting Started with QlikView for Data Visualization

• discover the key concepts covered in this course
• install and set up QlikView Personal on your local Windows machine
• use the built-in QlikView Movies example to illustrate QlikView's associative model
• import data from Excel into QlikView
• create and illustrate the use of a table box sheet object
• configure a basic bar chart and table that influence each other
• perform sort and filter operations on a bar chart
• create horizontal bar charts and visualize negative values
• import data from a CSV file into QlikView
• create a table box sheet object and a multi box sheet object to influence the other objects in a sheet
• create a pie chart to visualize the proportion of individual categories
• create and customize basic grid charts
• explore data using a trellis chart
• summarize the key concepts covered in this course

QlikView, a guided data analytics solution from Qlik, allows you to develop and deliver interactive guided analytics applications and dashboards rapidly. In this course, you'll set up QlikView Personal on your Microsoft Windows machine and build some standard visualizations.

You'll first demonstrate and explore in detail the associative data model in QlikView, which allows you to probe and highlight all associations in your data.

You'll then import custom data using Excel and CSV files into QlikView before visualizing and exploring your data using bar charts, pie charts, and grid charts.

Furthermore, you'll also use special sheet objects, such as the table box, which, when every row's content is logically connected, displays several fields in your data simultaneously. Moreover, you'll use the multi box to represent values from multiple fields as drop-down values.